ReportingPeriod

Entity Definition

Logical Name : ReportingPeriod
Physical Name : CA_PRD_RP

A time interval bounded by a starting and ending calendar period, used as the basis of all financial and performance reporting. Includes periods line DayPart, Shift, BusinessDay, Week, Month, Quarter and Year.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CalendarLevelID (FK) A unique system assigned identifier for the CalendarLevel. ID_CLD_LV Identity integer CalendarPeriod(CA_CLD_PRD)
CalendarID (FK) A unique system assigned identifier for the Calendar. ID_CLD Identity integer CalendarPeriod(CA_CLD_PRD)
ReportingPeriodID (PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer
CalendarID (FK) A unique system assigned identifier for the Calendar. ID_CLD Identity integer CalendarPeriod(CA_CLD_PRD)
CalendarLevelID (FK) A unique system assigned identifier for the CalendarLevel. ID_CLD_LV Identity integer CalendarPeriod(CA_CLD_PRD)
StartCalendarPeriodID (FK) A unique system assigned identifier for this CalendarPeriod ID_CLD_PRD_SRT Identity integer CalendarPeriod(CA_CLD_PRD)
EndCalendarPeriodID (FK) A unique system assigned identifier for this CalendarPeriod ID_CLD_PRD_END Identity integer CalendarPeriod(CA_CLD_PRD)
Name The business name for the reporting period. NM_PRD_RP Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
CalendarPeriod is the start of ReportingPeriod
CalendarPeriod is the end of ReportingPeriod
ReportingPeriod delineates StockLedgerAccountHistory
ReportingPeriod delineates ItemInventoryHistory
ReportingPeriod delineates CustomerAccountInvoice
ReportingPeriod delineates MerchandiseHierarchySalesSummary
ReportingPeriod defines time period of CustomerAccountJournal
ReportingPeriod delineates CustomerRentalAccountHistory
ReportingPeriod defines period for reporting of CustomerAccountLedgerHistory
ReportingPeriod delineates StoreHistory
ReportingPeriod delineates OperatorHistory
ReportingPeriod defines time interval for ExternalPurchasedCreditDebitCardSpendData
ReportingPeriod delineates WorkerTimeAccrualHistory
ReportingPeriod delineates RetailValuationLedgerAccountHistory
ReportingPeriod delineates WorkstationHistory
ReportingPeriod delineates CostValuationLedgerAccountHistory
ReportingPeriod delineates PromotionalOfferHistory
ReportingPeriod delineates WorkerDiscountedSalesHistory
ReportingPeriod defines time interval for WalletShareEstimate
ReportingPeriod delineates ItemSalesSummary
ReportingPeriod delineates RelatedItemAssociationSalesSummary
ReportingPeriod delineates POSDepartmentHistory
ReportingPeriod summarizes business at BusinessUnitGroupReportingPeriod
ReportingPeriod defines WorkstationReportingPeriod
ReportingPeriod delineates MerchandiseHierarchySalesPlan
ReportingPeriod delineates NozzleFuelingTransactionHistory
ReportingPeriod defines period for InventoryFact
ReportingPeriod delineates FinancialLedger
ReportingPeriod delineates PrepayHistory

Logical Views containing ReportingPeriod

Logical View
Logical 02400 - Control Transaction Macro View
Logical 02430 - Control Transaction - Period Open Close View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 03100 - Reporting - Store Operations - Macro View
Logical 03120 - Reporting - Store Operations - Period View
Logical 03140 - Reporting - Store Operations - Workstation View
Logical 03150 - Reporting - Store Operations - Operator View
Logical 03200 - Reporting - Item Sales View
Logical 03300 - Reporting - Stock Ledger View
Logical 05400 - Taxation - Reporting View - Tax Rule Reference
Logical 06100 - Calendar View
Logical 07040 - Customer Segment Dependent Behavior
Logical 07042 - Customer Wallet Share
Logical 10102 - EnterpriseWeather
Logical 10300 - Enterprise - POS Department View
Logical 11160 - Worker - Reporting View
Logical 20040 - Forecourt History View